{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Request for Cash","Consolidated Support","CAPER FY20","CAPER FY20 Cum","CAPERList"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Request for Cash","index":0,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[33,0,33,9],[45,0,45,1],[45,8,45,9],[34,0,36,9],[38,8,38,9],[39,6,39,7],[39,8,39,9],[38,6,38,7],[38,1,38,2],[40,6,40,7],[43,0,43,9],[44,0,44,1],[44,8,44,9],[40,1,40,3],[30,0,32,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[10,1,10,3],[4,4,4,6],[9,1,9,3],[7,1,7,3],[8,1,8,3],[27,0,27,9],[26,0,26,9],[3,1,3,3],[10,7,10,9],[5,1,5,3],[6,1,6,3],[6,5,6,6],[7,7,7,9],[8,7,8,9],[9,7,9,9]]}
["Mississippi Home Corporation"]
["Request for Cash"]
[]
["Program:","Emergency Solutions Grant Program CARES Act"]
["Section A:  General Information",null,null,null,"Section B:  Project Information"]
["Recipient",null,null,null,"Grant No.","Contract No.",null,"Project No."]
["Mailing Address",{"$f":"LOOKUP(+$B$6,C52:C72,D52:D72)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(+$B$6,C52:C72,H52:H72)","v":{"$error":"#N/A"}},{"$f":"LOOKUP(+$B$6,C52:C72,I52:I72)","v":{"$error":"#N/A"}}]
["Street Address",{"$f":"LOOKUP(+$B$6,C52:C72,E52:E72)","v":{"$error":"#N/A"}},null,null,"Services Rendered",null,null,"Request No."]
["City, State Zip",{"$f":"LOOKUP(+$B$6,C52:C72,F52:F72)","v":{"$error":"#N/A"}},null,null,"From",null,"To"]
["Telephone No.",{"$f":"LOOKUP(+$B$6,C52:C72,G52:G72)","v":{"$error":"#N/A"}},null,null,null,"Thru",null,"MHC Staff Initials"]
[]
["Section C:  Request Per Activity"]
[null,null,"Activity Description"," Budget Amount","Total Prior Request to Date","This Request","Remaining Balance",null,"Activity Numbers"]
[1,null,{"$f":"+'Consolidated Support'!B43","v":"Shelter"},{"$f":"+'Consolidated Support'!I43","v":0},{"$f":"+'Consolidated Support'!J8","v":0},{"$f":"+'Consolidated Support'!G43","v":0},{"$f":"+D14-E14-F14","v":0},null,15248]
[2,null,"Street Outreach",{"$f":"+'Consolidated Support'!I56","v":0},{"$f":"+'Consolidated Support'!J45","v":0},{"$f":"+'Consolidated Support'!G56","v":0},0,null,15247]
[3,null,"Rapid Rehousing",{"$f":"+'Consolidated Support'!I80","v":0},{"$f":"+'Consolidated Support'!J58","v":0},{"$f":"+'Consolidated Support'!G80","v":0},0,null,15250]
[4,null,"Homeless Prevention",{"$f":"'Consolidated Support'!I105","v":0},{"$f":"+'Consolidated Support'!J82","v":0},{"$f":"'Consolidated Support'!G105","v":0},0,null,15249]
[5,null,"HMIS",{"$f":"'Consolidated Support'!I118","v":0},{"$f":"+'Consolidated Support'!J107","v":0},{"$f":"'Consolidated Support'!G118","v":0},0,null,15251]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19]
[20,null,null,null,null,null,{"$f":"+D23-E23-F23","v":0}]
[null,null,"Total:",{"$f":"SUM(D14:D23)","v":0},{"$f":"SUM(E14:E23)","v":0},{"$f":"SUM(F14:F23)","v":0},{"$f":"SUM(G14:G23)","v":0}]
[]
[]
["Required Accomplishment Narrative "]
[]
[]
[]
["   I Hereby Certify That (a) the services covered by this request have not been received from the Federal Government/State Government or expended for such services under any other contract agreement or grant; (b) the amount requested will be expended for allowable costs / expenditures under the terms of the contract agreement or grant; (c) the amount requested herein does not exceed the total funds obligated by contract; and (d) the funds are requested for only immediate disbursements.  "]
[]
[]
[" By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award.  I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)."]
["   I Hereby Certify That the goods sold and/or services rendered have been delivered and/or performed in good order within the time listed above and are in compliance with all statutory requirements and regulations.  I certify that this request does not include any advances or funds for future obligations. "]
[]
[]
["Is this your final request for cash on this contract?",null,null,null,null,"YES",null,"NO"]
[]
[null,"           Signature of Authorized Official ",null,null,"Date Signed",null," Prepared By",null,"Date Prepared"]
[]
[null,"Typed Name and Title of Authorized Official",null,null,null,null,"Preparer's Telephone No."]
[]
[]
["IDIS Voucher Number",null,"Vendor Number","Issue/Series","Fund/Sub-Fund","Serviceer"]
[]
[]
[]
[]
[]
[null,null,"Applicant","Mailing Address","Street Address","City","Phone #","Grant No.","Contract No."]
[null,null,"ASC","P O Box 169",null,"Hattiesburg, MS  39403",6014504286,2019,"2019-ESGCV-ASC-20"]
[null,null,"Bolivar County Community Action Agency",null,"810 E. Sunflower Rd. Suite 120","Cleveland, MS  38732",6628461491,2019,"2019-ESGCV-BCAA-20"]
[null,null,"Carter's Compassionate Transitional & Supportive Hsg",null,"4657 Terry Road","Jackson, MS  39212",6016681221,2019,"2019-ESGCV-CCTSH-20"]
[null,null,"Community Care Network",null,"7400 Fountainbleau Road","Ocean Springs, MS  39564",2282152662,2019,"2019-ESGCV-CCN-20"]
[null,null,"Corporation for Global Community Development",null,"4655 Terry Road","Jackson, MS  39212",6015945064,2019,"2019-ESGCV-CGCD-20"]
[null,null,"Grace House, Inc",null,"236 Millsaps Avenue","Jackson, MS  39202",6013531038,2019,"2019-ESGCV-GHI-20"]
[null,null,"Gulf Coast Center for Nonviolence","P O Box 333",null,"Biloxi, MS  39533",2284363809,2019,"2019-ESGCV-GCCN-20"]
[null,null,"Mississippi Center for Justice","P O Box 1023",null,"Jackson, MS  39215",2285967359,2019,"2019-ESGCV-MCJ-20"]
[null,null,"Mississippi Center for Police & Sheriffs",null,"3363 Hwy 61 South","Vicksburg, MS  39180",6012609876,2019,"2019-ESGCV-MCPS-20"]
[null,null,"Mississippi United to End Homelessness",null,"201 W. Capitol St., Suite 800","Jackson, MS 39202",6019600557,2019,"2019-ESGCV-MUTEH-20"]
[null,null,"Open Door Homeless Coalititon",null,"11975 Seaway Road B-220","Gulfport, MS 39503","(228) 604-2048",2019,"2019-ESGCV-ODHC-20"]
[null,null,"Resilience Development Corporation",null,"106 Green Avenue","Mound Bayou, MS 38672",9018001404,2019,"2019-ESGCV-RDC-20"]
[null,null,"S.A.F.E., Inc.",null,"105 Clark Place","Tupelo, MS  38804",6628419105,2019,"2019-ESGCV-SAFE-20"]
[null,null,"Stewpot Community Services/Central MS CoC ",null,"1100 W. Capitol Street","Jackson, MS  39203","(601) 353-2759",2019,"2019-ESGCV-CMCoC-20"]
[null,null,"The Center for Nonviolence","P O Box 6279",null,"Pearl, MS  39288",6019324198,2019,"2019-ESGCV-CVP-20"]
[null,null,"The Salvation Army - Jackson",null,"110 Presto Lane","Jackson, MS  39206",6019824881,2019,"2019-ESGCV-TSAJ-20"]
[null,null,"USM-Institute for Disability Studies",null,"2609 W. 4th Street","Hattiesburg, MS  39406",6012664119,2019,"2019-ESGCV-USMIDS-20"]

{"sheet":"Consolidated Support","index":1,"n_rows":138,"n_cols":11,"rows_kept":138,"cut":false,"hidden":false,"merged":[[119,1,119,3],[137,1,137,3],[136,1,136,3],[136,7,136,8],[126,0,128,10],[130,0,131,10],[121,4,121,5],[124,5,124,6],[123,5,123,6],[134,7,134,8],[135,7,135,8],[132,0,132,10],[124,7,124,8],[124,2,124,3]]}
["Mississippi Home Corporation"]
[" Consolidated Support Sheet"]
[null,"Program:",{"$f":"+'Request for Cash'!B4","v":"Emergency Solutions Grant Program CARES Act"}]
[null,"Recipient",{"$f":"+'Request for Cash'!B6","v":0},null,null,null,null,"Contract Number:",{"$f":"+'Request for Cash'!F7","v":{"$error":"#N/A"}}]
[null,"Request for Cash Number:",{"$f":"+'Request for Cash'!H9","v":0},null,null,null,null,"Total Amount Requested:",{"$f":"+'Request for Cash'!F24","v":0}]
[]
["IDIS #  AWARD #","Line Items","CAPER Category","Vendor","Invoice #","Total Invoice","Amount of This Request","Notes","Amount Budgeted","Amount Requested to Date","Balance"]
[{"$f":"+'Request for Cash'!I14","v":15248},"Shelter",null,null,null,null,null,null,null,null,{"$f":"+I8-J8","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G9","v":0},{"$f":"+I9-J9","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G10","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+G12","v":0},{"$f":"+I12-J12","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B8","v":"Shelter"},null,null,null,{"$f":"SUM(F8:F42)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I15","v":15247},"Street Outreach",null,null,null,null,null,null,null,0,{"$f":"+I45-J45","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G46","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B45","v":"Street Outreach"},null,null,null,{"$f":"SUM(F45:F55)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I16","v":15250},"Rapid Re-Housing",null,null,null,null,null,null,null,0,{"$f":"+I58-J58","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G59","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+G62","v":0},{"$f":"+I62-J62","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"B58","v":"Rapid Re-Housing"},null,null,null,{"$f":"SUM(F58:F79)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I17","v":15249},"Homeless Prevention",null,null,null,null,null,null,null,0,{"$f":"+I82-J82","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G83","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+G91","v":0},{"$f":"+I91-J91","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B82","v":"Homeless Prevention"},null,null,null,{"$f":"SUM(F82:F104)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I18","v":15251},"HMIS",null,null,null,null,null,null,null,0,{"$f":"+I107-J107","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G108","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B107","v":"HMIS"},null,null,null,{"$f":"SUM(F107:F117)","v":0},0,0,0,0,0]
[]
[null,"GRAND TOTAL",null,null,null,{"$f":"F56+F118+F105+F80+F43","v":0},{"$f":"G56+G118+G105+G80+G43","v":0},null,{"$f":"I56+I118+I105+I80+I43","v":0},{"$f":"J56+J118+J105+J80+J43","v":0},{"$f":"K56+K118+K105+K80+K43","v":0}]
[]
[null,"Services Rendered - Beginning:",null,null,{"$f":"'Request for Cash'!E10","v":"00:00:00"},null,"Thru",{"$f":"+'Request for Cash'!G10","v":"00:00:00"}]
[]
[null,null,null,{"$f":"+J120","v":0},null,null,null,null,{"$f":"+D124","v":0}]
[null,"Cumulative:  ","Program Expenditures ",null,null,null,null,"Total Expenditures"]
[]
["   I Hereby Certify That (a) the services covered by this request have not been received from the Federal / State Government or expended for such services under any other contract agreement or grant; (b) the amount requested will be expended for allowable costs / expenditures under the terms of the contract agreement or grant; (c) the amount requested herein does not exceed the total funds obligated by contract; and (d) the funds are requested for only immediate disbursements."]
[]
[]
[]
["   I Hereby Certify That the goods sold and/or services rendered have been delivered and/or performed in good order within the time listed above and are in compliance with all statutory requirements and regulations.  I certify that this request does not include any advances or funds for future obligations."]
[]
[" By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award.  I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)."]
[]
[null,null,null,null,null,{"$f":"+'Request for Cash'!E39","v":"00:00:00"},null,{"$f":"+'Request for Cash'!G39","v":0}]
[null,"Signature of Authorized Official ",null,null,null,"Date Signed",null," Prepared By"]
[null,{"$f":"+'Request for Cash'!B41","v":0},null,null," ",null,null,{"$f":"+'Request for Cash'!G41","v":0}]
[null,"          Typed Name and Title of Authorized Official",null,null,null,null,null,"Preparer's Telephone No."]

{"sheet":"CAPER FY20","index":2,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[38,0,38,2],[7,0,7,2],[18,0,18,2],[28,0,28,2],[5,1,5,2]]}
[" Financial Summary Report (CAPER)"]
["Sub recipient",{"$f":"+'Request for Cash'!B6","v":0}]
["Contract Number",{"$f":"+'Request for Cash'!F7","v":{"$error":"#N/A"}}]
["Request for Cash Number",{"$f":"'Request for Cash'!H9","v":0}]
["Reporting Period From",{"$f":"'Request for Cash'!E10","v":"00:00:00"}]
["                            To",{"$f":"'Request for Cash'!G10","v":"00:00:00"}]
[null,null,"ESG CARES Act Expenditures by Categories "]
["ESG-CV Expenditures for Emergency Shelter"]
["Essential Services",null,{"$f":"SUMIF('Consolidated Support'!C9:C42,\"ESES*\",'Consolidated Support'!J9:J42)","v":0}]
["Operations",null,{"$f":"SUMIF('Consolidated Support'!C9:C42,\"ESOP*\",'Consolidated Support'!J9:J42)","v":0}]
["Renovation",null,{"$f":"SUMIF('Consolidated Support'!C9:C42,\"ESRV*\",'Consolidated Support'!J9:J42)","v":0}]
["Major Rehab",null,{"$f":"SUMIF('Consolidated Support'!C9:C42,\"ESRH*\",'Consolidated Support'!J9:J42)","v":0}]
["Conversion",null,0]
["Hazard Pay (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C9:C42,\"ESHP*\",'Consolidated Support'!J9:J42)","v":0}]
["Volunteer Incentives (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C9:C42,\"ESVI*\",'Consolidated Support'!J9:J42)","v":0}]
["Training (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C9:C42,\"ESTR*\",'Consolidated Support'!J9:J42)","v":0}]
["Subtotal",null,{"$f":"SUM(C9:C16)","v":0}]
[]
["ESG-CV Expenditures for Rapid Rehousing"]
["Rental Assistance",null,{"$f":"SUMIF('Consolidated Support'!C59:C79,\"RRRA*\",'Consolidated Support'!J59:J79)","v":0}]
["Housing Relocation and Stabilization Services - Financial Assistance",null,{"$f":"SUMIF('Consolidated Support'!C59:C79,\"RRFA*\",'Consolidated Support'!J59:J79)","v":0}]
["Housing Relocation and Stabilization Services - Services",null,{"$f":"SUMIF('Consolidated Support'!C59:C79,\"RRSS*\",'Consolidated Support'!J59:J79)","v":0}]
["Hazard Pay (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C59:C79,\"RRHP*\",'Consolidated Support'!J59:J79)","v":0}]
["Landlord Incentives (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C59:C79,\"RRLI*\",'Consolidated Support'!J59:J79)","v":0}]
["Volunteer Incentives (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C59:C79,\"RRVI*\",'Consolidated Support'!J59:J79)","v":0}]
["Training (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C59:C79,\"RRTR*\",'Consolidated Support'!J59:J79)","v":0}]
["Subtotal Rapid Rehousing",null,{"$f":"SUM(C20:C26)","v":0}]
[]
["ESG-CV Expenditures for Homelessness Prevention"]
["Rental Assistance",null,{"$f":"SUMIF('Consolidated Support'!C83:C104,\"HPRA*\",'Consolidated Support'!J83:J104)","v":0}]
["Housing Relocation and Stabilization Services - Financial Assistance",null,{"$f":"SUMIF('Consolidated Support'!C83:C104,\"HPFA*\",'Consolidated Support'!J83:J104)","v":0}]
["Housing Relocation and Stabilization Services - Services",null,{"$f":"SUMIF('Consolidated Support'!C83:C104,\"HPSS*\",'Consolidated Support'!J83:J104)","v":0}]
["Hazard Pay (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C83:C104,\"HPHP*\",'Consolidated Support'!J83:J104)","v":0}]
["Landlord Incentives (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C83:C104,\"HPLI*\",'Consolidated Support'!J83:J104)","v":0}]
["Volunteer Incentives (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C83:C104,\"HPVI*\",'Consolidated Support'!J83:J104)","v":0}]
["Training (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C83:C104,\"HPTR*\",'Consolidated Support'!J83:J104)","v":0}]
["Subtotal Homelessness Prevention",null,{"$f":"SUM(C30:C36)","v":0}]
[]
["Other Grant Expenditures"]
["Street Outreach",null,{"$f":"SUMIF('Consolidated Support'!C46:C55,\"SOES*\",'Consolidated Support'!J46:J55)","v":0}]
["Hazard Pay (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C46:C55,\"SOHP*\",'Consolidated Support'!J46:J55)","v":0}]
["Handwashing Stations, Portable BR & Laundry (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C46:C55,\"SOUA*\",'Consolidated Support'!J46:J55)","v":0}]
["Volunteer Incentives (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C46:C55,\"SOVI*\",'Consolidated Support'!J46:J55)","v":0}]
["Training (Unique Activity)",null,{"$f":"SUMIF('Consolidated Support'!C46:C55,\"SOTR*\",'Consolidated Support'!J46:J55)","v":0}]
["Subtotal Street Outreach",null,{"$f":"SUM(C40:C44)","v":0}]
[]
["HMIS",null,{"$f":"SUMIF('Consolidated Support'!C108:C117,\"HMIS*\",'Consolidated Support'!J108:J117)","v":0}]
["Administration",null,0]
[]
["Total ESG-CV Grant Funds",null,{"$f":"+C48+C47+C45+C37+C27+C17","v":0}]

{"sheet":"CAPER FY20 Cum","index":3,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[38,0,38,2],[28,0,28,2],[18,0,18,2],[7,0,7,2],[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["Cumulative Financial Summary Report (CAPER)"]
["Sub recipient",{"$f":"'Request for Cash'!B6:D6","v":0}]
["Contract Number",{"$f":"'Request for Cash'!F7","v":{"$error":"#N/A"}}]
["Request for Cash Number",{"$f":"'Consolidated Support'!C5","v":0}]
["Reporting Period From",{"$f":"'Request for Cash'!E10","v":"00:00:00"}]
["                            To",{"$f":"'Request for Cash'!G10","v":"00:00:00"}]
[null,null,"ESG-CV Expenditures by Categories   3/27/20 - 6/30/22"]
["ESG-CV Expenditures for Emergency Shelter"]
["Essential Services",null,0]
["Operations",null,0]
["Renovation",null,0]
["Major Rehab",null,0]
["Conversion",null,0]
["Hazard Pay (Unique Activity)",null,0]
["Volunteer Incentives (Unique Activity)",null,0]
["Training (Unique Activity)",null,0]
["Subtotal",null,0]
[]
["ESG-CV Expenditures for Rapid Rehousing"]
["Expenditures for Rental Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,0]
["Hazard Pay (Unique Activity)",null,0]
["Landlord Incentive (Unique Activity)",null,0]
["Volunteer Incentives (Unique Activity)",null,0]
["Training (Unique Activity)",null,0]
["Subtotal Rapid Rehousing",null,0]
[null,null,0]
["ESG-CV Expenditures for Homelessness Prevention"]
["Expenditures for Rental Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,0]
["Hazard Pay (Unique Activity)",null,0]
["Landlord Incentive (Unique Activity)",null,0]
["Volunteer Incentives (Unique Activity)",null,0]
["Training (Unique Activity)",null,0]
["Subtotal Homelessness Prevention",null,0]
[null,null,0]
["Other ESG-CV Grant Expenditures"]
["Street Outreach",null,0]
["Hazard Pay (Unique Activity)",null,0]
["Handwashing Stations, Portable BR & Laundry (Unique Activity)",null,0]
["Volunteer Incentives (Unique Activity)",null,0]
["Training (Unique Activity)",null,0]
["Subtotal Street Outreach",null,0]
[]
["HMIS",null,0]
["Administration",null,0]
[]
["Total ESG Grant Funds",null,0]
[]
[]
[null,null,0,null,{"$f":"C53+'CAPER FY20'!C53","v":0}]
[null,null,0,null,{"$f":"C54+'CAPER FY20'!C54","v":0}]
[null,null,0,null,{"$f":"C55+'CAPER FY20'!C55","v":0}]
[null,null,0,null,{"$f":"C56+'CAPER FY20'!C56","v":0}]
[null,null,0,null,{"$f":"C57+'CAPER FY20'!C57","v":0}]
[null,null,0,null,{"$f":"C58+'CAPER FY20'!C58","v":0}]

{"sheet":"CAPERList","index":4,"n_rows":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
["Category","SubCategory1","Category-SubCategory1","SubCategory2",null,"Eligible Items"]
["Emergency Shelter","Essential Services","ESES","ESES-Staff Cost",null,"Staff Cost"]
["Emergency Shelter","Essential Services","ESES","ESES-Case management",null,"Case management"]
["Emergency Shelter","Essential Services","ESES","ESES-Transportation",null,"Transportation"]
["Emergency Shelter","Operations","ESOP","ESOP-Maintenance",null,"Maintenance"]
["Emergency Shelter","Operations","ESOP","ESOP-Staff Cost",null,"Staff Cost"]
["Emergency Shelter","Operations","ESOP","ESOP-Case Management",null,"Case Management"]
["Emergency Shelter","Operations","ESOP","ESOP-Rent",null,"Rent"]
["Emergency Shelter","Operations","ESOP","ESOP-Security",null,"Security"]
["Emergency Shelter","Operations","ESOP","ESOP-Fuel",null,"Fuel"]
["Emergency Shelter","Operations","ESOP","ESOP-Equipment",null,"Equipment"]
["Emergency Shelter","Operations","ESOP","ESOP-Insurance/Professional Services",null,"Insurance/Professional Services"]
["Emergency Shelter","Operations","ESOP","ESOP-Utilities",null,"Utilities"]
["Emergency Shelter","Operations","ESOP","ESOP-Food",null,"Food"]
["Emergency Shelter","Operations","ESOP","ESOP-Furnishings",null,"Furnishings"]
["Emergency Shelter","Operations","ESOP","ESOP-Supplies for shelter",null,"Supplies for shelter"]
["Emergency Shelter","Operations","ESOP","ESOP-Hotel/Motel Vouchers",null,"Hotel/Motel Vouchers"]
["Emergency Shelter","Renovation","ESRV","ESRV-Renovation",null,"Eligible costs-labor, materials, tools, and other cost including major rehabilitation of ES or conversion into a ES."]
["Emergency Shelter","Major Rehab","ESRH","ESRH-Rehabilitation",null,"Eligible costs-labor, materials, tools, and other cost including major rehabilitation of ES or conversion into a ES."]
["Emergency Shelter","Conversion","ESCV","ESCV-Conversion",null,"Eligible costs-labor, materials, tools, and other cost including major rehabilitation of ES or conversion into a ES."]
["Emergency Shelter","Hazard Pay (Unique Activity)","ESHP","ESHP-Hazard Pay",null,"Hazard Pay "]
["Emergency Shelter","Volunteer Incentives (Unique Activity)","ESVI","ESVI-Volunteer Incentives",null,"Volunteer Incentives - funds used to provide reasonable incentives to volunteers who have been/are currently helping to provide necessary services during COVID-19 outbreak."]
["Emergency Shelter","Training (Unique Activity)","ESTR","ESTR-Training",null,"Training - funds may be used for training on infectious desease prevention and mitigation for staff working directly to prevent, prepare for and respond to COVID-19 persons who are at risk of homelessness."]
["Street Outreach","Essential Services","SOES","SOES-Engagement/Case Management/Transportation",null,"Engagement/Case Management/Transportation"]
["Street Outreach","Essential Services","SOES","SOES- Staff Cost",null,"Staff Cost "]
["Street Outreach","Hazard Pay (Unique Activity)","SOHP","SOHP-Hazard Pay",null,"Hazard Pay "]
["Street Outreach","Handwashing Stations, Portable Bathrooms, Laundry Service (Unique Activity)","SOUA","SOUA-Handwashing, Portable Bathroom & Laundry",null,"Handwashing Stations, Portable Bathrooms, Laundry Service - funds may be used to install and maintain handwashing stations and bathrooms in outdoor locationd for people experiencing unsheltered homelessness"]
["Street Outreach","Volunteer Incentives (Unique Activity)","SOVI","SOVI-Volunteer Incentives",null,"Volunteer Incentives - funds used to provide reasonable incentives to volunteers who have been/are currently helping to provide necessary services during COVID-19 outbreak."]
["Street Outreach","Training (Unique Activity)","SOTR","SOTR-Training",null,"Training - funds may be used for training on infectious desease prevention and mitigation for staff working directly to prevent, prepare for and respond to COVID-19 persons who are at risk of homelessness."]
["Rapid Rehousing","Expenditures for Rental Assistance","RRRA","RRRA-Rental payment",null,"Rental payment"]
["Rapid Rehousing","Expenditures for Rental Assistance","RRRA","RRRA-Rental arrearage payment",null,"Rental arrearage payment"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Rental application fees",null,"Rental application fees"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Security deposits",null,"Security deposits"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Last month rent",null,"Last month rent"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Utility deposit",null,"Utility deposit"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Utility payment",null,"Utility payment"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Moving costs",null,"Moving costs"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Staff Cost",null,"Staff Cost"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Housing stability case management",null,"Housing stability case management"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Housing search",null,"Housing search"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Placement",null,"Placement"]
["Rapid Rehousing","Hazard Pay (Unique Activity)","RRHP","RRHP-Hazard Pay",null,"Hazard Pay "]
["Rapid Rehousing","Landlord Incentives (Unique Activity)","RRLI","RRLI-Landlord Incentives",null,"Lanlord Incentives - funds can be used to pay landlords up to 3 times the rent for the unit"]
["Rapid Rehousing","Volunteer Incentives (Unique Activity)","RRVI","RRVI-Volunteer Incentives",null,"Volunteer Incentives - funds used to provide reasonable incentives to volunteers who have been/are currently helping to provide necessary services during COVID-19 outbreak."]
["Rapid Rehousing","Training (Unique Activity)","RRTR","RRTR-Training",null,"Training - funds may be used for training on infectious desease prevention and mitigation for staff working directly to prevent, prepare for and respond to COVID-19 persons who are at risk of homelessness."]
["Homeless Prevention","Expenditures for Rental Assistance","HPRA","HPRA-Rental payment",null,"Rental payment"]
["Homeless Prevention","Expenditures for Rental Assistance","HPRA","HPRA-Rental arrearage payment",null,"Rental arrearage payment"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Rental application fees",null,"Rental application fees"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Security Deposit",null,"Security Deposit"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Last month rent",null,"Last month rent"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Utility deposit",null,"Utility deposit"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Utility payment",null,"Utility payment"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Moving Cost",null,"Moving Cost"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Staff Cost",null,"Staff Cost"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Housing stability case management",null,"Housing stability case management"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Housing search",null,"Housing search"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Placement",null,"Placement"]
["Homeless Prevention","Hazard Pay (Unique Activity)","HPHP","HPHP-Hazard Pay",null,"Hazard Pay "]
["Homeless Prevention","Landlord Incentives (Unique Activity)","HPLI","HPLI-Landlord Incentives",null,"Lanlord Incentives - funds can be used to pay landlords up to 3 times the rent for the unit"]
["Homeless Prevention","Volunteer Incentives (Unique Activity)","HPVI","HPVI-Volunteer Incentives",null,"Volunteer Incentives - funds used to provide reasonable incentives to volunteers who have been/are currently helping to provide necessary services during COVID-19 outbreak."]
["Homeless Prevention","Training (Unique Activity)","HPTR","HPTR-Training",null,"Training - funds may be used for training on infectious desease prevention and mitigation for staff working directly to prevent, prepare for and respond to COVID-19 persons who are at risk of homelessness."]
["HMIS","Homeless Management Information System","HMIS","HMIS-Data support",null,"Data support"]